/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package sistemabienes;

import com.sun.data.provider.RowKey;
import com.sun.data.provider.impl.CachedRowSetDataProvider;
import com.sun.rave.web.ui.appbase.AbstractPageBean;
import com.sun.sql.rowset.CachedRowSetXImpl;
import com.sun.webui.jsf.component.Button;
import com.sun.webui.jsf.component.Calendar;
import com.sun.webui.jsf.component.StaticText;
import com.sun.webui.jsf.model.DefaultTableDataProvider;
import java.io.IOException;
import java.sql.CallableStatement;
import java.sql.SQLException;
import java.text.DateFormat;
import java.text.ParseException;
import java.util.Date;
import javax.faces.FacesException;
import javax.faces.event.ValueChangeEvent;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;


/**
 * <p>Page bean that corresponds to a similarly named JSP page.  This
 * class contains component definitions (and initialization code) for
 * all components that you have defined on this page, as well as
 * lifecycle methods and event handlers where you may add behavior
 * to respond to incoming events.</p>
 *
 * @version gestion.java
 * @version Created on 01-10-2010, 09:24:04 AM
 * @author luis
 */

public class gestion extends AbstractPageBean {
    // <editor-fold defaultstate="collapsed" desc="Managed Component Definition">

    /**
     * <p>Automatically managed component initialization.  <strong>WARNING:</strong>
     * This method is automatically generated, so any user-specified code inserted
     * here is subject to being replaced.</p>
     */
    private void _init() throws Exception {

        gestionRowSet.setDataSourceName("java:comp/env/jdbc/ACTIVOS_FIJOS_Oracle");
        gestionRowSet.setCommand("SELECT cod_gestion,to_char(fecha_ini,'DD-MM-YYYY') as Fecha_Inicial,to_char(fecha_fin,'DD-MM-YYYY') as Fecha_Final FROM ACTIVOS_FIJOS.GESTION order by cod_gestion asc");
        gestionRowSet.setTableName("gestion");
        gestionDataProvider.setCachedRowSet((javax.sql.rowset.CachedRowSet) getValue("#{gestion.gestionRowSet}"));
    }
    private Calendar calendar1 = new Calendar();

    public Calendar getCalendar1() {
        return calendar1;
    }

    public void setCalendar1(Calendar c) {
        this.calendar1 = c;
    }
    private Calendar calendar2 = new Calendar();

    public Calendar getCalendar2() {
        return calendar2;
    }

    public void setCalendar2(Calendar c) {
        this.calendar2 = c;
    }
    private Button button1 = new Button();

    public Button getButton1() {
        return button1;
    }

    public void setButton1(Button b) {
        this.button1 = b;
    }
     private CachedRowSetXImpl gestionRowSet = new CachedRowSetXImpl();

    public CachedRowSetXImpl getGestionRowSet() {
        return gestionRowSet;
    }

    public void setGestionRowSet(CachedRowSetXImpl crsxi) {
        this.gestionRowSet = crsxi;
    }
    private CachedRowSetDataProvider gestionDataProvider = new CachedRowSetDataProvider();

    public CachedRowSetDataProvider getGestionDataProvider() {
        return gestionDataProvider;
    }

    public void setGestionDataProvider(CachedRowSetDataProvider crsdp) {
        this.gestionDataProvider = crsdp;
    }
    private StaticText validation = new StaticText();

    public StaticText getValidation() {
        return validation;
    }

    public void setValidation(StaticText st) {
        this.validation = st;
    }
    private Button validateb = new Button();

    public Button getValidateb() {
        return validateb;
    }

    public void setValidateb(Button b) {
        this.validateb = b;
    }

    // </editor-fold>

    /**
     * <p>Construct a new Page bean instance.</p>
     */
    public gestion() throws Exception {
         boolean us=this.getSessionBean1().isloged();

        if(us==false)
        {
            throw new Exception("Permiso denegado");

        }
    }

    /**
     * <p>Callback method that is called whenever a page is navigated to,
     * either directly via a URL, or indirectly via page navigation.
     * Customize this method to acquire resources that will be needed
     * for event handlers and lifecycle methods, whether or not this
     * page is performing post back processing.</p>
     * 
     * <p>Note that, if the current request is a postback, the property
     * values of the components do <strong>not</strong> represent any
     * values submitted with this request.  Instead, they represent the
     * property values that were saved for this view when it was rendered.</p>
     */
    @Override
    public void init() {
        // Perform initializations inherited from our superclass
        super.init();
        // Perform application initialization that must complete
        // *before* managed components are initialized
        // TODO - add your own initialiation code here
        
        // <editor-fold defaultstate="collapsed" desc="Managed Component Initialization">
        // Initialize automatically managed components
        // *Note* - this logic should NOT be modified
        try {
            _init();
        } catch (Exception e) {
            log("gestion Initialization Failure", e);
            throw e instanceof FacesException ? (FacesException) e: new FacesException(e);
        }
        
        // </editor-fold>
        // Perform application initialization that must complete
        // *after* managed components are initialized
        // TODO - add your own initialization code here
    }


    /**
     * <p>Callback method that is called after the component tree has been
     * restored, but before any event processing takes place.  This method
     * will <strong>only</strong> be called on a postback request that
     * is processing a form submit.  Customize this method to allocate
     * resources that will be required in your event handlers.</p>
     */
    @Override
    public void preprocess() {
    }

    /**
     * <p>Callback method that is called just before rendering takes place.
     * This method will <strong>only</strong> be called for the page that
     * will actually be rendered (and not, for example, on a page that
     * handled a postback and then navigated to a different page).  Customize
     * this method to allocate resources that will be required for rendering
     * this page.</p>
     */
    @Override
    public void prerender() {
    }

    /**
     * <p>Callback method that is called after rendering is completed for
     * this request, if <code>init()</code> was called (regardless of whether
     * or not this was the page that was actually rendered).  Customize this
     * method to release resources acquired in the <code>init()</code>,
     * <code>preprocess()</code>, or <code>prerender()</code> methods (or
     * acquired during execution of an event handler).</p>
     */
    @Override
    public void destroy() {
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected RequestBean1 getRequestBean1() {
        return (RequestBean1) getBean("RequestBean1");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected SessionBean1 getSessionBean1() {
        return (SessionBean1) getBean("SessionBean1");
    }

    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected ApplicationBean1 getApplicationBean1() {
        return (ApplicationBean1) getBean("ApplicationBean1");
    }

    public String button1_action() throws NamingException, ParseException, IOException {
        // TODO: Process the action. Return value is a navigation
        // case name where null will return to the same page.
        Date in=calendar1.getSelectedDate();
        java.sql.Date ini = new java.sql.Date(in.getTime());
       
        Date fi=calendar2.getSelectedDate();
        java.sql.Date fin = new java.sql.Date(fi.getTime());
        if(calendar1.getText()==null)
         {   //if(txtci.getValue().toString()==null)
            error("no se permite Campo vacio");}
            else{
                if(calendar2.getText()==null)
                 {
                    error("no se permite Campo vacio");

                 }else{
                    if(fin.compareTo(ini) == 0){
                            error("No se permite Fechas iguales ");
                    }else
                    if(fin.compareTo(ini) > 0)
                    {  try{

                            boolean valor= insertargest(calendar1.getSelectedDate(),calendar2.getSelectedDate());
                      if(valor==true)
                      
                           // JOptionPane.showMessageDialog(null,"se inserto correctamente",JOptionPane.WARNING_MESSAGE);
                          error("se inserto correctamente");
                           //JOptionPane.showMessageDialog(null,1, "ERROR", JOptionPane.WARNING_MESSAGE);
                            getGestionDataProvider().refresh();
                            //label4.setVisible(true);
                     //label4.setValue(valor.toString());

                      }catch (SQLException e)
                            {
                                error(e.getMessage());
                            }
                    }else{
                        error("la fecha inicial no puede ser mayor a la fecha final");
                    }     
                }
            }
        return null;

    }

    public boolean insertargest (Date fechai, Date fechaf) throws NamingException, SQLException,ParseException,IOException
    {

     try{
                String dataSourceName=
                        this.getGestionRowSet().getDataSourceName();
                 Context ctx= new InitialContext();
                 DataSource ds=(DataSource) ctx.lookup(dataSourceName);

                 CallableStatement cs1 = ds.getConnection().prepareCall("CALL activos_fijos.INSERTGESTION(?,?)");
                    cs1.setDate(1,new java.sql.Date(fechai.getTime()));
                    cs1.setDate(2,new java.sql.Date(fechaf.getTime()));

                cs1.executeQuery();
                //label3.setText(new java.sql.Date(fecha.getTime()));
                return true;
     }catch(SQLException e)
            {
                error(e.getMessage());

            }
     return false;
    }

    public String seleccionar_action() {
        // TODO: Replace with your code
        
        return null;
    }

    public String validateb_action() {
        validation.setText(
                (String)DateFormat.getDateInstance(

            DateFormat.MEDIUM).format(calendar1.getSelectedDate())
                + " is a valid date.");
        return null;
    }

}

